Hello,
on Oracle 10g I can not set up Users in the security menu.
Either
The Orcale ojdbc14.jar driver is installed.
Which driver I have to selected at the DB Server Setup?
Two driver are appearing:
oracle.jdbc.OracleDriver and
oracle.jdbc.driver.OracleDriver
Why that, and which one to use?
ledergerber:
on Oracle 10g I can not set up Users in the security menu.Either
- Can type new User in, but they are gone, selecting the security menu again.
or- selecting the security menu, I get a message that said “Cannot show security dialog”.
My guess is that you are using Servoy 2.2.x here? (it seems we forgot to merge a fix back from Servoy 3.x to 2.2.x.)
ledergerber:
The Orcale ojdbc14.jar driver is installed.Which driver I have to selected at the DB Server Setup?
Two driver are appearing:
oracle.jdbc.OracleDriver and
oracle.jdbc.driver.OracleDriverWhy that, and which one to use?
Oracle tagged multiple files as being a driver, google told us that “oracle.jdbc.driver.OracleDriver” is the driver to use…
My guess is that you are using Servoy 2.2.x here? (it seems we forgot to merge a fix back from Servoy 3.x to 2.2.x.)
Yes we were trying Servoy 2.2.x and Orcale 10g.
Because it did not work at all, we had to go for Servoy 3.0.1. With Servoy 3.0 we do not have that problem.
Please let us know if the bugfix is done in Servoy 2.2.x.
Looks like we are the only one working with Servoy 2.2.x and Oracle 10g ?
Oracle tagged multiple files as being a driver, google told us that “oracle.jdbc.driver.OracleDriver” is the driver to use
Thank you for the info!
In Servoy 2.2.7 it is still not possible to create users in an Oracle 10g database. This is currently a real problem for us!
We just tested user creation in Servoy 2.2.7 again with Oracle 10.2 and the Oracle 10.2 jdbc driver and all works fine. (Oracle 10.2 is also known as 10g)
So its a hard for us to understand what is going wrong…are you sure you use the correct driver?
I am using the oracle ojdbc14.jar and the driver oracle.jdbc.driver.OracleDriver.
I will try to download the latest version from Oracle and try again.
Oracle 10.2 ships with a driver jar called “classes12.jar”
Yes, I know. The last time I had to deal with Oracle I remember this to be a nightmare. And we eventually were successful with the driver I am using now. I have been using this driver ever since. But now I installed a new Oracle and have that problem…
I will try the classes12.jar, but I think I remember there was some other problem to it.
Pretty amazing stuff:
classes12.jar (1,594,191 bytes) - for use with JDK 1.2 and JDK 1.3
classes12_g.jar (2,038,127 bytes) - same as classes12.jar, except that classes were compiled with “javac -g” and contain some tracing information.
classes12dms.jar (1,601,843 bytes) - same as classes12.jar, except that it contains additional codeto support Oracle Dynamic Monitoring Service. classes12dms_g.jar (2,046,467 bytes) - same as classes12dms.jar except that classes were compiled with "javac -g" and contain some tracing information. ojdbc14.jar (1,540,457 bytes) - classes for use with JDK 1.4 and 1.5 ojdbc14_g.jar (1,932,834 bytes) - same as ojdbc14.jar, except that classes were compiled with "javac -g" and contain some tracing information. ojdbc14dms.jar (1,548,006 bytes) - same as ojdbc14.jar, except that it contains additional codeto support Oracle Dynamic Monitoring Service.
ojdbc14dms_g.jar (1,940,478 bytes) - same as ojdbc14dms.jar, except that classes were compiled with “javac -g” and contain some tracing information.
orai18n.jar (1,645,109 bytes) - NLS classes for use with JDK 1.2, 1.3, 1.4, and 1.5. This jar file replaces the old nls_charset jar/zip files.
And this is for 10g Release 2 (10.2.0.2) only! For 10g Release 2 (10.2.0.1.0) you have another list like that. So it comes down to the fourth digit of the version number. But hey, Oracle is not for kids!
Anyway, it sounds like classes12 is not the one to use. But I will try with their very latest ojdbc14…
OK. I have tried again. I have downloaded a preinstalled VMWare with Linux and Oracle 10.1.0.3.0 (every digit might count!). I have downloaded and tried all types of drivers from the Oracle site. The last thing I did was to extract the driver from the InstantClient-Install that came with the VMWare download.
No luck. Whatever I do I get this:
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: ORA-01400: cannot insert NULL into ("REPOSITORY"."SERVOY_USERS"."
USER_ID")
ORA-01400: cannot insert NULL into ("REPOSITORY"."SERVOY_USERS"."USER_ID")
So what’s next?
Thanks
Patrick
Hi Patrick,
I have had multiple problems too with the various Oracle drivers. They really do a crap job in my opinion. I went through a lot of trouble shooting with Aqua Data Studio too with this. Eventually what we found is that the ‘best’ driver is one that is simply called ‘oracle.jar’. We use this on our server which is 9i currently but we will be moving to 10g tomorrow. Supposedly this is the main and best driver to use for BOTH 10g and 9i although of course I don’t yet have any experience in using it for 10g. I’m told that the ojdbc14.jar driver is the one that comes with Oracle Client but Aqua Data Studio at least does NOT use that and, when we were having problems of various kinds, he had me do a search to make sure that I did NOT have that driver on my system. I would suggest getting at least a trial copy of Aqua Data Studio because it comes bundled with the driver I’ve been using and which is supposedly the ‘best’, most current one to use, rather than getting lost in the forest at Oracle !!
P.S. I’d highly recommend Aqua Data Studio in any case by the way. Besides their first class support like Servoy’s, they are always up to date with ALL JDBC compliant SQL databases and which drivers to use, etc. Really a perfect tool and especially if you are going back and forth between different database vendors.
Thanks, John. I have been using Aqua Data Studio for years but never had the idea of using their driver. I will try that NOW.
Just tried :
java.sql.SQLException: ORA-01400: cannot insert NULL into (“SALESMANAGER_REPOSITORY”.“SERVOY_USERS”.“USER_ID”)
When you look at the error, it says that USER_ID is provided a NULL value. Servoy should fetch the next sequence and use it in this query. So to me the problem seems to be the retrieval of the next sequence rather than this statement. I’d be glad if someone from Servoy could point out what is exactly done when generating this query, so we can figure out where the problem is.
Here are the details of what goes on:
repository_server: Got connection, thread=AWT-EventQueue-0
used sql select SERVOY_USER_GROUPS.USER_GROUP_ID, SERVOY_USER_GROUPS.USER_ID, SERVOY_USER_GROUPS.GROUP_ID from SERVOY_USER_GROUPS where SERVOY_USER_GROUPS.GROUP_ID = ? order by SERVOY_USER_GROUPS.USER_GROUP_ID questiondata.lenght 1
questiondata[0]= 1.0 ,type: java.lang.Double
repository_server: Closed connection, thread=AWT-EventQueue-0
query Done for RelatedFoundSet: 2 1.0 17960685 useCache: true THREAD: AWT-EventQueue-0, Time: 62
repository_server: Got connection, thread=AWT-EventQueue-0
used question less sql select SERVOY_USERS.USER_ID from SERVOY_USERS order by SERVOY_USERS.USER_ID
repository_server: Closed connection, thread=AWT-EventQueue-0
RefreshFrom DB time: 16 thread: AWT-EventQueue-0, SQL: select SERVOY_USERS.USER_ID from SERVOY_USERS order by SERVOY_USERS.USER_ID
repository_server: Got connection, thread=TaskExecuter[0]
used sql select SERVOY_GROUP_ELEMENTS.GROUP_ELEMENT_ID, SERVOY_GROUP_ELEMENTS.GROUP_ID, SERVOY_GROUP_ELEMENTS.ELEMENT_ID, SERVOY_GROUP_ELEMENTS.ELEMENT_ACCESS, SERVOY_GROUP_ELEMENTS.COLUMNINFO_ACCESS, SERVOY_GROUP_ELEMENTS.SOLUTION_ID from SERVOY_GROUP_ELEMENTS where SERVOY_GROUP_ELEMENTS.GROUP_ID = ? and SERVOY_GROUP_ELEMENTS.SOLUTION_ID = ? order by SERVOY_GROUP_ELEMENTS.GROUP_ELEMENT_ID questiondata.lenght 2
questiondata[0]= 1.0 ,type: java.lang.Double
questiondata[1]= 1.0 ,type: java.lang.Double
repository_server: Closed connection, thread=TaskExecuter[0]
query Done for RelatedFoundSet: 1 1.01.0 17960685 useCache: true THREAD: TaskExecuter[0], Time: 16
size of LoginDialog_Anmeldung java.awt.Point[x=902,y=472]
repository_server: Got connection, thread=AWT-EventQueue-0
used sql select count(*) from servoy_users where user_name = ? questiondata.lenght 1
questiondata[0]= ‘system’ ,type: java.lang.String
repository_server: Closed connection, thread=AWT-EventQueue-0
repository_server: Got connection, thread=AWT-EventQueue-0
sql insert into SERVOY_USERS ( USER_ID, USER_NAME, USER_PASSWORD) values ( ? , ? , ? )
questiondata[0]= NullValue with type: 3 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue
questiondata[1]= ‘system’ ,type: java.lang.String
questiondata[2]= ‘DFAnXFSznuFhFz1M5AfHKg==’ ,type: java.lang.String
repository_server: Closed connection, thread=AWT-EventQueue-0
java.sql.SQLException: ORA-01400: cannot insert NULL into (“SALESMANAGER_REPOSITORY”.“SERVOY_USERS”.“USER_ID”)
and the problem is here:
questiondata[0]= NullValue with type: 3 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue
Maybe helpful to note, that on the server admin page/users it says:
Could not list users: null
I remember this being a problem for a while, but thought it was gone. Maybe the issue is related.
Hi Patrick,
I probably read your post too quickly thinking it was a driver issue (I’m rather knee-jerk with that on Oracle) and I think you are right in that the two are related. Hard to blame it on the Oracle Driver in inserting a ‘null’ in a not null column I guess! But just to let you know regarding ADS and Oracle issues that ADS is coming out this weekend with ADS 6 (skipped 5 altogether!) as a Release Candidate. I’ve been using it as a tester for the last month or so and proof-reading the documentation and I’d highly recommend it. Came up with some very cool features. I’d also recommend joining their mailing list because their advice really is first class with database/driver issues. Actually I think I’ll post this in the database section as well.
To me everything seems to work great, but Servoy doesn’t seem to be able to get the right sequence. Since I don’t see the queries they do for that, I cannot see what goes wrong…
Hate to say that: I have a Oracle 10g Express version 10.2.0.1.0 - Product and have exactly the same problem.