George L.
|
| Posted: 06/07/2002, 2:05 PM |
|
Hey. Has anyone had success doing table joins in CCS, using Oracle?
I know that in CC 2.0.5, they had an Oracle Join Style that you could select in the Database Properties. This is not available in CCS 1.0
I'm wondering because non of the table joins that I do through Visual Query seem to work correctly.
The joins always return ALL rows from the joined table, rather than just rows that match the primary_key of the first table. I've even tried all three join types available: inner;left;right. All have the same results.
|
|
|
 |
Ron Borkent
|
| Posted: 06/08/2002, 1:52 AM |
|
I've been sick so I couldn't test CCS 1.0 on the company's Oracle database I'll try on monday and report my findings here.
I suppose you could do the SQL stuff yourself. Use visual query builder to do the large part of the work. Then switch from table to sql(should take all your selections and show the query CCS build based on selections in visual query builder) adjust joins as needed.
Ron
|
|
|
|
Efren Lugo
|
| Posted: 06/12/2002, 11:05 AM |
|
George L. do you can show tables in JSP proyects???
i got an exception maybe you can help...
java.lang.NullPointerException
at com.codecharge.db.JDBCConnection.createPreparedStatement(JDBCConnection.java:728)
at com.codecharge.db.SqlCommand.prepareCommand(SqlCommand.java:155)
i configure my CCS to:
Connection String: jdbc:oracle:thin:@127.0.0.1:1521:sintec
Connection Driver: oracle.jdbc.driver.OracleDriver
Connection URL: jdbc:oracle:thin:@127.0.0.1:1521:sintec
Num Connection DB: unlimited
Time out: 500
this is correct???
|
|
|
|
CodeCharge Support
|
| Posted: 06/13/2002, 2:51 AM |
|
Efren,
please refer to response in support system
|
|
|
|
George L.
|
| Posted: 06/13/2002, 1:44 PM |
|
Yes has already identified it as a possible bug. They are working on a possible solution.
Visual Query builder (table joins only) is just not workin using Oracle/PHP combination.
|
|
|
|
George L.
|
| Posted: 06/13/2002, 1:44 PM |
|
Yes has already identified it as a possible bug. They are working on a possible solution.
Visual Query builder (table joins only) is just not workin using Oracle/PHP combination.
|
|
|
|
Efren Lugo
|
| Posted: 06/14/2002, 2:32 PM |
|
I had the same problems with joins dont work no matter what option you select SQL, TABLE, etc...
when i try to get a relationated value from another table i get an error on ASPNET... this dont happen with access databases...
I think oracle sql statement would be different from msaccess or or microsoft SQL...
there is a patch or something that can resolve this???
i had use Microsoft Oracle ODBC drivers insted of Oracle ones... and i get an error in Microsoft ones, y get success with Oracle ones, but its imposible link tables...
|
|
|
|
George L.
|
| Posted: 06/18/2002, 8:28 AM |
|
Efren. As of today, there is no patch for this. It is a genuine bug though. I cannot get any join on ANY table to work at all, using Oracle/PHP combo.
There are ways around it though. None are desirable.
One thing you can do is use old CodeCharge as a template to build the same kind of grid or record that you are trying to build in CCS. This sucks big time though, cause then you have to extract the generated SQL statement from old C.C. and apply it to your CCS template, using the manual SQL feature.
This problem is severely stopping me from moving forward. Yes is appearently working on the the issue though.
|
|
|
|
