craftleft.gif (3002 bytes)QuickTable
Home | API | Tutorial | Download | Support | Contact topblack.gif (108 bytes)


QuickTable User Cp  |  Register  |  Members  |  Search  |  Help
    |- QuickTable Discussion Forums > JDBC/Database Issues Post New Topic   Post A Reply
VAJ3.02 --> InstantDB not connecting printer friendly version
next newest post | next oldest post
Author Messages
cwynn{@}ndak.net
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 19:00:00  

I already have the my application connecting with designated tables that were generated by InstantDB
I just installed QuickTable11.
Hope you know a little about the VAJ IDE

Can I make a connection between QT and the VAJ DBNavigator Bean? as I was expecting.
I can not find a property to connect to from the bean that I have already established connection with.

I have to create a second connection (I suspect a problem in that the table is already opened).

I've tried using the URL and Driver name that I use for connecting with the VAJ SelectBean.
This does not work. I get an error "unable to find the database driverr" when I click on QT in the application.

I setup the properties with the following
URL --> jdbc:idb:C:/idb/databases/cenex.prp
driver --> jdbd.idbDriver

please keep in mind I running the application withing Visual Age for Java (VAJ)

admin{@}quicktable.org
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 19:00:00  

If you have already created the database connection in your project , you can reuse that. Have a look at the tutorial where I give an example for this type at http://quicktable.org/tutorial/existingConnection.htm

Regarding unable to find driver is a problem with VAJ. Even I have faced the same problem. If you just add the driver to VAJ classpath setting, it will never find it. Finally I end up in importing all the driver class files into project. This solved the problem.

Ben
I already have the my application connecting with designated tables that were generated by InstantDB
I just installed QuickTable11.
Hope you know a little about the VAJ IDE

Can I make a connection between QT and the VAJ DBNavigator Bean? as I was expecting.
I can not find a property to connect to from the bean that I have already established connection with.

I have to create a second connection (I suspect a problem in that the table is already opened).

I've tried using the URL and Driver name that I use for connecting with the VAJ SelectBean.
This does not work. I get an error "unable to find the database driverr" when I click on QT in the application.

I setup the properties with the following
URL --> jdbc:idb:C:/idb/databases/cenex.prp
driver --> jdbd.idbDriver

please keep in mind I running the application withing Visual Age for Java (VAJ)



cywnn{@}ndak.net
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 19:00:00  

The situation has changed !

I used the connection wizard to setup QT11.
QT11 connects to the "instantDB" tables.

Next VAJ3.02 needs to generate its code. It fails
reporting 2 error. I'm not at my work
site to report the exact context of the
errors. I will follow up on this tomorrow.

It suffice to say VAJ3.02 has got a
problem with the values be saved in
the properties code. I suspect it does
not recognize some properties that you
QT specifies.


If you have already created the database connection in your project , you can reuse that. Have a look at the tutorial where I give an example for this type at http://quicktable.org/tutorial/existingConnection.htm

Regarding unable to find driver is a problem with VAJ. Even I have faced the same problem. If you just add the driver to VAJ classpath setting, it will never find it. Finally I end up in importing all the driver class files into project. This solved the problem.

Ben
I already have the my application connecting with designated tables that were generated by InstantDB
I just installed QuickTable11.
Hope you know a little about the VAJ IDE

Can I make a connection between QT and the VAJ DBNavigator Bean? as I was expecting.
I can not find a property to connect to from the bean that I have already established connection with.

I have to create a second connection (I suspect a problem in that the table is already opened).

I've tried using the URL and Driver name that I use for connecting with the VAJ SelectBean.
This does not work. I get an error "unable to find the database driverr" when I click on QT in the application.

I setup the properties with the following
URL --> jdbc:idb:C:/idb/databases/cenex.prp
driver --> jdbd.idbDriver

please keep in mind I running the application withing Visual Age for Java (VAJ)





admin{@}quicktable.org
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 19:00:00  

Lot of IDEs don't generate code for the property changes.
Also Sun's Javabean spec doesn't say much about code generation, it assumes we all are going to use serialization. spec talks very less about code genration by IDE. This is the main reason why most IDEs don't generate good code for property changes. To solve this problem, if you use quicktable customizer, it will generate the code for all the property changes, so that you can copy and paste the code into your source.

have a look at http://quicktable.org/tour5.htm where you can see a sample of generated code by quicktable.

Ben
The situation has changed !

I used the connection wizard to setup QT11.
QT11 connects to the "instantDB" tables.

Next VAJ3.02 needs to generate its code. It fails
reporting 2 error. I'm not at my work
site to report the exact context of the
errors. I will follow up on this tomorrow.

It suffice to say VAJ3.02 has got a
problem with the values be saved in
the properties code. I suspect it does
not recognize some properties that you
QT specifies.

cwynn{@}ndak.net
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 19:00:00  

This message box was filled with previous messages?
I couldn't find where to post this follow up so I deleted the contents

[Do not know how to generate code for the ''bounds'' property of the ''qtblCustomer'' bean. No code will be generated for this property setting.
Do not know how to generate code for the ''connection'' property of the ''qtblCustomer'' bean. No code will be generated for this property setting.]

After all is said and done I can not get VAJ to create the beans it needs even after I've inserted the code from the customizer.

I acutally get QT working using the code the customizer generates. I note that the "connection" property gets updated after finnishing the customizer. If I could hand code that property maybe I could get around my problem.

I'm not sure what is happening here. When I finish with the customizer, I can test run the application and it's working. Then I must do a "save" which VAJ then goes about generating code. This when it fails and "does not" generate the necessary bean. Above message in [ ] is output to the screen

I inserted the fix code from the customizer into a class that gets this application working with QT. Apparently some other feature of VAJ bean generation that I'm not aware of is failing and the fix isn't being picked up and put in the class code.

does this make sense?

admin{@}quicktable.org
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 19:00:00  

I understand the problem fully. Basically I feel that this is due to some limitation in Javabean spec.
lets say I want to set the width of a column, The object oriented way of calling this method will be
quicktable.getColumn(1).setWidth(20);

as per java spec it should be
quicktable.setColumnWidth(1,20);
For me , I beleive the object oriented way is better. But if I implement that way the code generator won't generate any code for this property.
Similarly , if there is a method
quicktable.setConnection(myConnection);
In javabean spec, there is no way to interospect the user program code to get the name of connection instance variable.so there is no way to generate code for this method.

I would really love to hear from you whether there is any way to fix the above kind of problems in a javabean.

Ben

cwynn{@}ndak.net
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 19:00:00  

I wish I could answer this but I'm not sure I understand. If I did I'd probably be writting my own component.

I am not sure why if VAJ has seeminly succeeded to introspect other parts of your code why's it hanging on these two properties "bounds" and "setconnetion"?

Is this problem specific to VAJ or does JBuilder etc fail to?

thank you
Craig

if you get a fix please email me

Post New Topic   Post A Reply Jump to:
Contact Us | QuickTable - A Java DBGrid | Privacy Policy All times are GMT -5 Hours.
Welcome to QuickTable Forums, Guest!  
Login
Username :
Password :
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!
Powered by CuteCast v2.0 BETA 2
Copyright © 2001-2003 ArtsCore Studios