Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
I have used Date.valueOf(String). But submitting the form Null Pointer Exception is thrown. While submitting i have created an object of Application.java and the class with getter and setters. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4508800.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
Just parse the date string into a Timestamp. That's Java, not Wicket. "RAM /abr./: Rarely Adequate Memory." From: SudeepShakya To: users@wicket.apache.org Date: 03/26/2012 11:03 PM Subject:Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc I want to know how to input date into database using form. I am using Timestamp in mysql. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4507896.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org ** This email and any attachments may contain information that is confidential and/or privileged for the sole use of the intended recipient. Any use, review, disclosure, copying, distribution or reliance by others, and any forwarding of this email or its contents, without the express permission of the sender is strictly prohibited by law. If you are not the intended recipient, please contact the sender immediately, delete the e-mail and destroy all copies. **
RE: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
> I want to know how to input date into database using form. I am using > Timestamp in mysql. The Wicket-related psrt of that question is that you use a TextField with a model, and you then get the model object value in onSubmit() and use normal SQL to insert or update. - Tor Iver - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
I want to know how to input date into database using form. I am using Timestamp in mysql. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4507896.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
http://www.wicket-library.com/wicket-examples/dates/ On Mon, Mar 26, 2012 at 9:55 AM, SudeepShakya wrote: > I have viewed some of the examples but not appropriate one. Can u give some > hint > > -- > View this message in context: > http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4505882.html > Sent from the Users forum mailing list archive at Nabble.com. > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
I have viewed some of the examples but not appropriate one. Can u give some hint -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4505882.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
Have you looked at the examples from the website? On Mar 26, 2012 7:20 AM, "SudeepShakya" wrote: > I have created a form which takes two dates/time and a textbox and created > a > class for get/set. > And, it should work as : when i insert the data, it should check the data > in > the database and display the filtered data as specified by the inputs . > Also i have created a jdbc connection and a method for retrieving data . > I don't know how to create a textbox that takes date/time as input and it > will be easy to the user to input. > I have created following files which I have attached. And also created html > files for form input and filtered display. > > Thanx for response. > > http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteCollection.java > VoteCollection.java > > http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteCollectionJDBC.java > VoteCollectionJDBC.java > > http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteDisplayPage.java > VoteDisplayPage.java > http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteEditForm.java > VoteEditForm.java > http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteEditPage.java > VoteEditPage.java > http://apache-wicket.1842946.n4.nabble.com/file/n4505444/Votes.java > Votes.java > > -- > View this message in context: > http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4505444.html > Sent from the Users forum mailing list archive at Nabble.com. > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > >
Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
I have created a form which takes two dates/time and a textbox and created a class for get/set. And, it should work as : when i insert the data, it should check the data in the database and display the filtered data as specified by the inputs . Also i have created a jdbc connection and a method for retrieving data . I don't know how to create a textbox that takes date/time as input and it will be easy to the user to input. I have created following files which I have attached. And also created html files for form input and filtered display. Thanx for response. http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteCollection.java VoteCollection.java http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteCollectionJDBC.java VoteCollectionJDBC.java http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteDisplayPage.java VoteDisplayPage.java http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteEditForm.java VoteEditForm.java http://apache-wicket.1842946.n4.nabble.com/file/n4505444/VoteEditPage.java VoteEditPage.java http://apache-wicket.1842946.n4.nabble.com/file/n4505444/Votes.java Votes.java -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4505444.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
Hi, what exactly is your problem? What problems are you having so far? I am new to wicket and also to webframeworks. i am creating an app, which has a homepage and when a link is clicked, it should display a form which takes two dates and a string as input and retrieves data from database. Thanks in advance. I tried to learn from 'wicket in action' but the example codes do not work much wicket 1.4. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4505124.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Creating a submit form which takes date and a string as input and displays the data from database(mysql) using simple jdbc
I am new to wicket and also to webframeworks. i am creating an app, which has a homepage and when a link is clicked, it should display a form which takes two dates and a string as input and retrieves data from database. Thanks in advance. I tried to learn from 'wicket in action' but the example codes do not work much wicket 1.4. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/Creating-a-submit-form-which-takes-date-and-a-string-as-input-and-displays-the-data-from-database-myc-tp4505124p4505124.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
Hej, 2010/2/16 Hauke Ingmar Schmidt : > 2010/2/11 Giambalvo, Christian : >> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html > > Unrelated to the original posters question, but: The sort method used > in this sample does not work correctly. It gets a sublist and sorts > the sublist instead of sorting the base data and getting the sublist > from the sorted data. It doesn't show in the sample because no paging > is used and the base data is already sorted. Fixed. And I "generified" the example. Hej då Hauke Ingmar - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
Hej, 2010/2/11 Giambalvo, Christian : > http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html Unrelated to the original posters question, but: The sort method used in this sample does not work correctly. It gets a sublist and sorts the sublist instead of sorting the base data and getting the sublist from the sorted data. It doesn't show in the sample because no paging is used and the base data is already sorted. Hej då Hauke Ingmar - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Re: Re: jdbc
Thank you all guys! I just do it with Map. Especially thanks to Leo.Erlandsson! 2010/2/15 : > Should be no different when using JDBC than using it when using Domain > Objects. > > Check out Wicket Phonebook Example that uses FilterToolbar: > http://wicketstuff.org/confluence/display/STUFFWIKI/wicket-phonebook > > Source Code Example: > https://wicket-stuff.svn.sourceforge.net/svnroot/wicket-stuff/trunk/wicketstuff-core/phonebook/src/main/java/wicket/contrib/phonebook/web/page/ListContactsPage.java > > >> Thank you! >> I just discovered this sample: >> http://www.brettdutton.com/blog/?p=4 > >> What i can do.. if i want to use FilterToolbar with DataTable? > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Re: Re: jdbc
Should be no different when using JDBC than using it when using Domain Objects. Check out Wicket Phonebook Example that uses FilterToolbar: http://wicketstuff.org/confluence/display/STUFFWIKI/wicket-phonebook Source Code Example: https://wicket-stuff.svn.sourceforge.net/svnroot/wicket-stuff/trunk/wicketstuff-core/phonebook/src/main/java/wicket/contrib/phonebook/web/page/ListContactsPage.java > Thank you! > I just discovered this sample: > http://www.brettdutton.com/blog/?p=4 > What i can do.. if i want to use FilterToolbar with DataTable?
Re: jdbc
Sorry, man. Some things just have to be left as an exercise for the
reader. That's not a Wicket question.
On Mon, Feb 15, 2010 at 6:14 AM, Ivan Dudko wrote:
> now problem is not accessing object fields..
>
> problem is transform resultset to these objects..
>
> 2010/2/12 James Carman :
>> You could create a reference from Honey to Milk, since you have a
>> "milkid" field there. Then, you'd use a list of Honey objects and
>> you'd display these properties:
>>
>> id
>> milk.id
>> name
>> milk.name
>>
>>
>>
>>
>> On Fri, Feb 12, 2010 at 3:58 AM, Ivan Dudko wrote:
>>> For example..
>>> class Honey {
>>> int id;
>>> int milkid;
>>> String name;
>>> // getters and setters
>>> }
>>> class Milk {
>>> int id;
>>> String name;
>>> // getters and setters
>>> }
>>>
>>> and my query:
>>> SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
>>> milk.name MILKNAME FROM honey, milk
>>> WHERE honey.milkid=milk.id;
>>>
>>> And i want to display table with these fields.
>>>
>>> Which object i must use?
>>>
>>> 2010/2/11 James Carman :
>>>> Well, what sort of object do you want to display? Are you going to
>>>> just create an Object[] for each row in the table? Or, are you
>>>> creating a DTO of some sort?
>>>>
>>>> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko wrote:
>>>>> Thank you.
>>>>> I already do simple things with hibernate and spring ioc.
>>>>> Now i want to use plain old jdbc.
>>>>> I already get the datatable wich works with one pojo (table).
>>>>> Now i am in trouble.. how i can get table for two joined tables, for
>>>>> example?
>>>>>
>>>>> 2010/2/11 James Carman :
>>>>>> Yeah, but this doesn't give them an example of how to get the results
>>>>>> out of a JDBC result set. This is based on a static, in-memory list
>>>>>> of Contact objects. What I would recommend is to look at a
>>>>>> Hibernate-based example and come up with the JDBC analog. Here's an
>>>>>> example from my Advanced Wicket talk I gave a while back:
>>>>>>
>>>>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main/java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java
>>>>>>
>>>>>> At the bottom, there's a data provider which talks to a "repository"
>>>>>> to get its data.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
>>>>>> wrote:
>>>>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html
>>>>>>>
>>>>>>> -Ursprüngliche Nachricht-
>>>>>>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com]
>>>>>>> Gesendet: Donnerstag, 11. Februar 2010 15:47
>>>>>>> An: users@wicket.apache.org
>>>>>>> Betreff: Re: jdbc
>>>>>>>
>>>>>>> I already have method that return my data from db as arraylist. And i
>>>>>>> use this in iterator() method of dataprovider.
>>>>>>> But which object (i think model) i must return?
>>>>>>>
>>>>>>> 2010/2/11 James Carman :
>>>>>>>> You need to create a "provider" for your data. Look at what the
>>>>>>>> constructor takes and then implement the interface.
>>>>>>>>
>>>>>>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko
>>>>>>>> wrote:
>>>>>>>>> Hello!
>>>>>>>>>
>>>>>>>>> I can't understand how to populate data from a resultset object into
>>>>>>>>> datatable.
>>>>>>>>> Anyone have an example?
>>>>>>>>>
>>>>>>>>> Thank you!
>>>>>>>>>
>>>>>>>>> -
>>>>>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>&
Re: Re: jdbc
Thank you!
I just discovered this sample:
http://www.brettdutton.com/blog/?p=4
What i can do.. if i want to use FilterToolbar with DataTable?
2010/2/15 :
> If you want to use a Map and display it in a Datatable there's no
> difference from using an Object in Wicket.
>
> You access the key/values using PropertyColumn as usual (i.e. you don't
> really need to make any changes to your code). For Objects you use e. g.
> "name" for the getName() method. When using Maps "name" will return the
> value corresponding to the key "name".
>
>
>
>
>> Can you give me an example, how i can use ResultSet transformed into
>> Map with for example datatable component?
>> I think i can write method transforming ResultSet to a Map.
>>
>> I do not want to use any ORM, because web tier for my app is just
>> "control panel" and main features implemented in the backend.
>
>> You want to swim without getting wet. Fine :)
>
>> public class MyMilkFactory {
>> public List provideHoneyObjects() {
>> // iterate over sql statement/REsultSet
>> Milk milk = createMilk(rs);
>> Honey honey provideHoney(rs.getInteger("honeyid"));
>>
>> }
>>
>> public Milk createMilk(ResultSet rs) { // do not use an
> OR/mapper here
>> but do the dirty work on your own}
>>
>> public Honey provideHoney(int id) {//read from database,
> again do the
>> dirty work on your own }
>>}
>
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
Re: Re: jdbc
If you want to use a Map and display it in a Datatable there's no
difference from using an Object in Wicket.
You access the key/values using PropertyColumn as usual (i.e. you don't
really need to make any changes to your code). For Objects you use e. g.
"name" for the getName() method. When using Maps "name" will return the
value corresponding to the key "name".
> Can you give me an example, how i can use ResultSet transformed into
> Map with for example datatable component?
> I think i can write method transforming ResultSet to a Map.
>
> I do not want to use any ORM, because web tier for my app is just
> "control panel" and main features implemented in the backend.
> You want to swim without getting wet. Fine :)
> public class MyMilkFactory {
>public List provideHoneyObjects() {
>// iterate over sql statement/REsultSet
> Milk milk = createMilk(rs);
> Honey honey provideHoney(rs.getInteger("honeyid"));
>
>}
>
>public Milk createMilk(ResultSet rs) { // do not use an
OR/mapper here
> but do the dirty work on your own}
>
>public Honey provideHoney(int id) {//read from database,
again do the
> dirty work on your own }
>}
Re: jdbc
> Can you give me an example, how i can use ResultSet transformed into
> Map with for example datatable component?
> I think i can write method transforming ResultSet to a Map.
>
> I do not want to use any ORM, because web tier for my app is just
> "control panel" and main features implemented in the backend.
You want to swim without getting wet. Fine :)
public class MyMilkFactory {
public List provideHoneyObjects() {
// iterate over sql statement/REsultSet
Milk milk = createMilk(rs);
Honey honey provideHoney(rs.getInteger("honeyid"));
}
public Milk createMilk(ResultSet rs) { // do not use an OR/mapper here
but do the dirty work on your own}
public Honey provideHoney(int id) {//read from database, again do the
dirty work on your own }
}
> 2010/2/15 Ilja Pavkovic :
> > use any preferred OR mapper like hibernate, toplink,
> >
> >> now problem is not accessing object fields..
> >>
> >> problem is transform resultset to these objects..
> >>
> >> 2010/2/12 James Carman :
> >> > You could create a reference from Honey to Milk, since you have a
> >> > "milkid" field there. Then, you'd use a list of Honey objects and
> >> > you'd display these properties:
> >> >
> >> > id
> >> > milk.id
> >> > name
> >> > milk.name
> >> >
> >> > On Fri, Feb 12, 2010 at 3:58 AM, Ivan Dudko
wrote:
> >> >> For example..
> >> >> class Honey {
> >> >> int id;
> >> >> int milkid;
> >> >> String name;
> >> >> // getters and setters
> >> >> }
> >> >> class Milk {
> >> >> int id;
> >> >> String name;
> >> >> // getters and setters
> >> >> }
> >> >>
> >> >> and my query:
> >> >> SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
> >> >> milk.name MILKNAME FROM honey, milk
> >> >> WHERE honey.milkid=milk.id;
> >> >>
> >> >> And i want to display table with these fields.
> >> >>
> >> >> Which object i must use?
> >> >>
> >> >> 2010/2/11 James Carman :
> >> >>> Well, what sort of object do you want to display? Are you going to
> >> >>> just create an Object[] for each row in the table? Or, are you
> >> >>> creating a DTO of some sort?
> >> >>>
> >> >>> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko
> >
> > wrote:
> >> >>>> Thank you.
> >> >>>> I already do simple things with hibernate and spring ioc.
> >> >>>> Now i want to use plain old jdbc.
> >> >>>> I already get the datatable wich works with one pojo (table).
> >> >>>> Now i am in trouble.. how i can get table for two joined tables,
> >> >>>> for example?
> >> >>>>
> >> >>>> 2010/2/11 James Carman :
> >> >>>>> Yeah, but this doesn't give them an example of how to get the
> >> >>>>> results out of a JDBC result set. This is based on a static,
> >> >>>>> in-memory list of Contact objects. What I would recommend is to
> >> >>>>> look at a Hibernate-based example and come up with the JDBC
> >> >>>>> analog. Here's an example from my Advanced Wicket talk I gave a
> >> >>>>> while back:
> >> >>>>>
> >> >>>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/m
> >> >>>>> ain
> >> >>>>> /java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.j
> >> >>>>> ava
> >> >>>>>
> >> >>>>> At the bottom, there's a data provider which talks to a
> >> >>>>> "repository" to get its data.
> >> >>>>>
> >> >>>>>
> >> >>>>>
> >> >>>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
> >> >>>>>
> >> >>>>> wrote:
> >> >>>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.
> >> >>>>>> htm l
> >> >>>>>>
> >&g
Re: jdbc
Can you give me an example, how i can use ResultSet transformed into
Map with for example datatable component?
I think i can write method transforming ResultSet to a Map.
I do not want to use any ORM, because web tier for my app is just
"control panel" and main features implemented in the backend.
2010/2/15 Ilja Pavkovic :
> use any preferred OR mapper like hibernate, toplink,
>
>> now problem is not accessing object fields..
>>
>> problem is transform resultset to these objects..
>>
>> 2010/2/12 James Carman :
>> > You could create a reference from Honey to Milk, since you have a
>> > "milkid" field there. Then, you'd use a list of Honey objects and
>> > you'd display these properties:
>> >
>> > id
>> > milk.id
>> > name
>> > milk.name
>> >
>> > On Fri, Feb 12, 2010 at 3:58 AM, Ivan Dudko wrote:
>> >> For example..
>> >> class Honey {
>> >> int id;
>> >> int milkid;
>> >> String name;
>> >> // getters and setters
>> >> }
>> >> class Milk {
>> >> int id;
>> >> String name;
>> >> // getters and setters
>> >> }
>> >>
>> >> and my query:
>> >> SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
>> >> milk.name MILKNAME FROM honey, milk
>> >> WHERE honey.milkid=milk.id;
>> >>
>> >> And i want to display table with these fields.
>> >>
>> >> Which object i must use?
>> >>
>> >> 2010/2/11 James Carman :
>> >>> Well, what sort of object do you want to display? Are you going to
>> >>> just create an Object[] for each row in the table? Or, are you
>> >>> creating a DTO of some sort?
>> >>>
>> >>> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko
> wrote:
>> >>>> Thank you.
>> >>>> I already do simple things with hibernate and spring ioc.
>> >>>> Now i want to use plain old jdbc.
>> >>>> I already get the datatable wich works with one pojo (table).
>> >>>> Now i am in trouble.. how i can get table for two joined tables, for
>> >>>> example?
>> >>>>
>> >>>> 2010/2/11 James Carman :
>> >>>>> Yeah, but this doesn't give them an example of how to get the results
>> >>>>> out of a JDBC result set. This is based on a static, in-memory list
>> >>>>> of Contact objects. What I would recommend is to look at a
>> >>>>> Hibernate-based example and come up with the JDBC analog. Here's an
>> >>>>> example from my Advanced Wicket talk I gave a while back:
>> >>>>>
>> >>>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main
>> >>>>> /java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java
>> >>>>>
>> >>>>> At the bottom, there's a data provider which talks to a "repository"
>> >>>>> to get its data.
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
>> >>>>>
>> >>>>> wrote:
>> >>>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.htm
>> >>>>>> l
>> >>>>>>
>> >>>>>> -Ursprüngliche Nachricht-
>> >>>>>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com]
>> >>>>>> Gesendet: Donnerstag, 11. Februar 2010 15:47
>> >>>>>> An: users@wicket.apache.org
>> >>>>>> Betreff: Re: jdbc
>> >>>>>>
>> >>>>>> I already have method that return my data from db as arraylist. And
>> >>>>>> i use this in iterator() method of dataprovider.
>> >>>>>> But which object (i think model) i must return?
>> >>>>>>
>> >>>>>> 2010/2/11 James Carman :
>> >>>>>>> You need to create a "provider" for your data. Look at what the
>> >>>>>>> constructor takes and then implement the interface.
>> >>>>>>>
>> >>>>>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko
> wrote:
>> >&g
Re: jdbc
use any preferred OR mapper like hibernate, toplink,
> now problem is not accessing object fields..
>
> problem is transform resultset to these objects..
>
> 2010/2/12 James Carman :
> > You could create a reference from Honey to Milk, since you have a
> > "milkid" field there. Then, you'd use a list of Honey objects and
> > you'd display these properties:
> >
> > id
> > milk.id
> > name
> > milk.name
> >
> > On Fri, Feb 12, 2010 at 3:58 AM, Ivan Dudko wrote:
> >> For example..
> >> class Honey {
> >> int id;
> >> int milkid;
> >> String name;
> >> // getters and setters
> >> }
> >> class Milk {
> >> int id;
> >> String name;
> >> // getters and setters
> >> }
> >>
> >> and my query:
> >> SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
> >> milk.name MILKNAME FROM honey, milk
> >> WHERE honey.milkid=milk.id;
> >>
> >> And i want to display table with these fields.
> >>
> >> Which object i must use?
> >>
> >> 2010/2/11 James Carman :
> >>> Well, what sort of object do you want to display? Are you going to
> >>> just create an Object[] for each row in the table? Or, are you
> >>> creating a DTO of some sort?
> >>>
> >>> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko
wrote:
> >>>> Thank you.
> >>>> I already do simple things with hibernate and spring ioc.
> >>>> Now i want to use plain old jdbc.
> >>>> I already get the datatable wich works with one pojo (table).
> >>>> Now i am in trouble.. how i can get table for two joined tables, for
> >>>> example?
> >>>>
> >>>> 2010/2/11 James Carman :
> >>>>> Yeah, but this doesn't give them an example of how to get the results
> >>>>> out of a JDBC result set. This is based on a static, in-memory list
> >>>>> of Contact objects. What I would recommend is to look at a
> >>>>> Hibernate-based example and come up with the JDBC analog. Here's an
> >>>>> example from my Advanced Wicket talk I gave a while back:
> >>>>>
> >>>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main
> >>>>> /java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java
> >>>>>
> >>>>> At the bottom, there's a data provider which talks to a "repository"
> >>>>> to get its data.
> >>>>>
> >>>>>
> >>>>>
> >>>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
> >>>>>
> >>>>> wrote:
> >>>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.htm
> >>>>>> l
> >>>>>>
> >>>>>> -Ursprüngliche Nachricht-
> >>>>>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com]
> >>>>>> Gesendet: Donnerstag, 11. Februar 2010 15:47
> >>>>>> An: users@wicket.apache.org
> >>>>>> Betreff: Re: jdbc
> >>>>>>
> >>>>>> I already have method that return my data from db as arraylist. And
> >>>>>> i use this in iterator() method of dataprovider.
> >>>>>> But which object (i think model) i must return?
> >>>>>>
> >>>>>> 2010/2/11 James Carman :
> >>>>>>> You need to create a "provider" for your data. Look at what the
> >>>>>>> constructor takes and then implement the interface.
> >>>>>>>
> >>>>>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko
wrote:
> >>>>>>>> Hello!
> >>>>>>>>
> >>>>>>>> I can't understand how to populate data from a resultset object
> >>>>>>>> into datatable. Anyone have an example?
> >>>>>>>>
> >>>>>>>> Thank you!
> >>>>>>>>
> >>>>>>>> --
> >>>>>>>> --- To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
> >>>>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>
Re: Re: jdbc
>now problem is not accessing object fields.. >problem is transform resultset to these objects.. You could just work with Maps in Wicket instead of Domain Objects. The transformation from ResultSet to a Map containing the Column name as Key and the data as Value should be trivial (if not; reply and I'll provide sample code) using MetaData (this is how we do it in our JSP pages today). Or you could write / find a software that does the mapping from JDBC ResultSet to Domain Objects... But why not use an ORM such as Hibernate / Cayenne / iBatis then.. ?
Re: jdbc
now problem is not accessing object fields..
problem is transform resultset to these objects..
2010/2/12 James Carman :
> You could create a reference from Honey to Milk, since you have a
> "milkid" field there. Then, you'd use a list of Honey objects and
> you'd display these properties:
>
> id
> milk.id
> name
> milk.name
>
>
>
>
> On Fri, Feb 12, 2010 at 3:58 AM, Ivan Dudko wrote:
>> For example..
>> class Honey {
>> int id;
>> int milkid;
>> String name;
>> // getters and setters
>> }
>> class Milk {
>> int id;
>> String name;
>> // getters and setters
>> }
>>
>> and my query:
>> SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
>> milk.name MILKNAME FROM honey, milk
>> WHERE honey.milkid=milk.id;
>>
>> And i want to display table with these fields.
>>
>> Which object i must use?
>>
>> 2010/2/11 James Carman :
>>> Well, what sort of object do you want to display? Are you going to
>>> just create an Object[] for each row in the table? Or, are you
>>> creating a DTO of some sort?
>>>
>>> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko wrote:
>>>> Thank you.
>>>> I already do simple things with hibernate and spring ioc.
>>>> Now i want to use plain old jdbc.
>>>> I already get the datatable wich works with one pojo (table).
>>>> Now i am in trouble.. how i can get table for two joined tables, for
>>>> example?
>>>>
>>>> 2010/2/11 James Carman :
>>>>> Yeah, but this doesn't give them an example of how to get the results
>>>>> out of a JDBC result set. This is based on a static, in-memory list
>>>>> of Contact objects. What I would recommend is to look at a
>>>>> Hibernate-based example and come up with the JDBC analog. Here's an
>>>>> example from my Advanced Wicket talk I gave a while back:
>>>>>
>>>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main/java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java
>>>>>
>>>>> At the bottom, there's a data provider which talks to a "repository"
>>>>> to get its data.
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
>>>>> wrote:
>>>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html
>>>>>>
>>>>>> -Ursprüngliche Nachricht-
>>>>>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com]
>>>>>> Gesendet: Donnerstag, 11. Februar 2010 15:47
>>>>>> An: users@wicket.apache.org
>>>>>> Betreff: Re: jdbc
>>>>>>
>>>>>> I already have method that return my data from db as arraylist. And i
>>>>>> use this in iterator() method of dataprovider.
>>>>>> But which object (i think model) i must return?
>>>>>>
>>>>>> 2010/2/11 James Carman :
>>>>>>> You need to create a "provider" for your data. Look at what the
>>>>>>> constructor takes and then implement the interface.
>>>>>>>
>>>>>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko
>>>>>>> wrote:
>>>>>>>> Hello!
>>>>>>>>
>>>>>>>> I can't understand how to populate data from a resultset object into
>>>>>>>> datatable.
>>>>>>>> Anyone have an example?
>>>>>>>>
>>>>>>>> Thank you!
>>>>>>>>
>>>>>>>> -
>>>>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> -
>>>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> -
&
Re: jdbc
You could create a reference from Honey to Milk, since you have a
"milkid" field there. Then, you'd use a list of Honey objects and
you'd display these properties:
id
milk.id
name
milk.name
On Fri, Feb 12, 2010 at 3:58 AM, Ivan Dudko wrote:
> For example..
> class Honey {
> int id;
> int milkid;
> String name;
> // getters and setters
> }
> class Milk {
> int id;
> String name;
> // getters and setters
> }
>
> and my query:
> SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
> milk.name MILKNAME FROM honey, milk
> WHERE honey.milkid=milk.id;
>
> And i want to display table with these fields.
>
> Which object i must use?
>
> 2010/2/11 James Carman :
>> Well, what sort of object do you want to display? Are you going to
>> just create an Object[] for each row in the table? Or, are you
>> creating a DTO of some sort?
>>
>> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko wrote:
>>> Thank you.
>>> I already do simple things with hibernate and spring ioc.
>>> Now i want to use plain old jdbc.
>>> I already get the datatable wich works with one pojo (table).
>>> Now i am in trouble.. how i can get table for two joined tables, for
>>> example?
>>>
>>> 2010/2/11 James Carman :
>>>> Yeah, but this doesn't give them an example of how to get the results
>>>> out of a JDBC result set. This is based on a static, in-memory list
>>>> of Contact objects. What I would recommend is to look at a
>>>> Hibernate-based example and come up with the JDBC analog. Here's an
>>>> example from my Advanced Wicket talk I gave a while back:
>>>>
>>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main/java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java
>>>>
>>>> At the bottom, there's a data provider which talks to a "repository"
>>>> to get its data.
>>>>
>>>>
>>>>
>>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
>>>> wrote:
>>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html
>>>>>
>>>>> -Ursprüngliche Nachricht-
>>>>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com]
>>>>> Gesendet: Donnerstag, 11. Februar 2010 15:47
>>>>> An: users@wicket.apache.org
>>>>> Betreff: Re: jdbc
>>>>>
>>>>> I already have method that return my data from db as arraylist. And i
>>>>> use this in iterator() method of dataprovider.
>>>>> But which object (i think model) i must return?
>>>>>
>>>>> 2010/2/11 James Carman :
>>>>>> You need to create a "provider" for your data. Look at what the
>>>>>> constructor takes and then implement the interface.
>>>>>>
>>>>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote:
>>>>>>> Hello!
>>>>>>>
>>>>>>> I can't understand how to populate data from a resultset object into
>>>>>>> datatable.
>>>>>>> Anyone have an example?
>>>>>>>
>>>>>>> Thank you!
>>>>>>>
>>>>>>> -
>>>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> -
>>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>>
>>>>>>
>>>>>
>>>>> -
>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>
>>>>>
>>>>> -
>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>
>>>>>
>>>>
>>>> -
>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>
>>>>
>>>
>>> -
>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>
>>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> For additional commands, e-mail: users-h...@wicket.apache.org
>>
>>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
> For additional commands, e-mail: users-h...@wicket.apache.org
>
>
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
For example..
class Honey {
int id;
int milkid;
String name;
// getters and setters
}
class Milk {
int id;
String name;
// getters and setters
}
and my query:
SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
milk.name MILKNAME FROM honey, milk
WHERE honey.milkid=milk.id;
And i want to display table with these fields.
Which object i must use?
2010/2/11 James Carman :
> Well, what sort of object do you want to display? Are you going to
> just create an Object[] for each row in the table? Or, are you
> creating a DTO of some sort?
>
> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko wrote:
>> Thank you.
>> I already do simple things with hibernate and spring ioc.
>> Now i want to use plain old jdbc.
>> I already get the datatable wich works with one pojo (table).
>> Now i am in trouble.. how i can get table for two joined tables, for example?
>>
>> 2010/2/11 James Carman :
>>> Yeah, but this doesn't give them an example of how to get the results
>>> out of a JDBC result set. This is based on a static, in-memory list
>>> of Contact objects. What I would recommend is to look at a
>>> Hibernate-based example and come up with the JDBC analog. Here's an
>>> example from my Advanced Wicket talk I gave a while back:
>>>
>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main/java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java
>>>
>>> At the bottom, there's a data provider which talks to a "repository"
>>> to get its data.
>>>
>>>
>>>
>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
>>> wrote:
>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html
>>>>
>>>> -Ursprüngliche Nachricht-
>>>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com]
>>>> Gesendet: Donnerstag, 11. Februar 2010 15:47
>>>> An: users@wicket.apache.org
>>>> Betreff: Re: jdbc
>>>>
>>>> I already have method that return my data from db as arraylist. And i
>>>> use this in iterator() method of dataprovider.
>>>> But which object (i think model) i must return?
>>>>
>>>> 2010/2/11 James Carman :
>>>>> You need to create a "provider" for your data. Look at what the
>>>>> constructor takes and then implement the interface.
>>>>>
>>>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote:
>>>>>> Hello!
>>>>>>
>>>>>> I can't understand how to populate data from a resultset object into
>>>>>> datatable.
>>>>>> Anyone have an example?
>>>>>>
>>>>>> Thank you!
>>>>>>
>>>>>> -
>>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>>
>>>>>>
>>>>>
>>>>> -
>>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>>
>>>>>
>>>>
>>>> -
>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>
>>>>
>>>> -
>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>>
>>>>
>>>
>>> -
>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>>> For additional commands, e-mail: users-h...@wicket.apache.org
>>>
>>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> For additional commands, e-mail: users-h...@wicket.apache.org
>>
>>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
> For additional commands, e-mail: users-h...@wicket.apache.org
>
>
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
Well, what sort of object do you want to display? Are you going to just create an Object[] for each row in the table? Or, are you creating a DTO of some sort? On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko wrote: > Thank you. > I already do simple things with hibernate and spring ioc. > Now i want to use plain old jdbc. > I already get the datatable wich works with one pojo (table). > Now i am in trouble.. how i can get table for two joined tables, for example? > > 2010/2/11 James Carman : >> Yeah, but this doesn't give them an example of how to get the results >> out of a JDBC result set. This is based on a static, in-memory list >> of Contact objects. What I would recommend is to look at a >> Hibernate-based example and come up with the JDBC analog. Here's an >> example from my Advanced Wicket talk I gave a while back: >> >> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main/java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java >> >> At the bottom, there's a data provider which talks to a "repository" >> to get its data. >> >> >> >> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian >> wrote: >>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html >>> >>> -Ursprüngliche Nachricht- >>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com] >>> Gesendet: Donnerstag, 11. Februar 2010 15:47 >>> An: users@wicket.apache.org >>> Betreff: Re: jdbc >>> >>> I already have method that return my data from db as arraylist. And i >>> use this in iterator() method of dataprovider. >>> But which object (i think model) i must return? >>> >>> 2010/2/11 James Carman : >>>> You need to create a "provider" for your data. Look at what the >>>> constructor takes and then implement the interface. >>>> >>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote: >>>>> Hello! >>>>> >>>>> I can't understand how to populate data from a resultset object into >>>>> datatable. >>>>> Anyone have an example? >>>>> >>>>> Thank you! >>>>> >>>>> - >>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >>>>> For additional commands, e-mail: users-h...@wicket.apache.org >>>>> >>>>> >>>> >>>> - >>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >>>> For additional commands, e-mail: users-h...@wicket.apache.org >>>> >>>> >>> >>> - >>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >>> For additional commands, e-mail: users-h...@wicket.apache.org >>> >>> >>> - >>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >>> For additional commands, e-mail: users-h...@wicket.apache.org >>> >>> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
Thank you. I already do simple things with hibernate and spring ioc. Now i want to use plain old jdbc. I already get the datatable wich works with one pojo (table). Now i am in trouble.. how i can get table for two joined tables, for example? 2010/2/11 James Carman : > Yeah, but this doesn't give them an example of how to get the results > out of a JDBC result set. This is based on a static, in-memory list > of Contact objects. What I would recommend is to look at a > Hibernate-based example and come up with the JDBC analog. Here's an > example from my Advanced Wicket talk I gave a while back: > > http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main/java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java > > At the bottom, there's a data provider which talks to a "repository" > to get its data. > > > > On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian > wrote: >> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html >> >> -Ursprüngliche Nachricht- >> Von: Ivan Dudko [mailto:ivan.du...@gmail.com] >> Gesendet: Donnerstag, 11. Februar 2010 15:47 >> An: users@wicket.apache.org >> Betreff: Re: jdbc >> >> I already have method that return my data from db as arraylist. And i >> use this in iterator() method of dataprovider. >> But which object (i think model) i must return? >> >> 2010/2/11 James Carman : >>> You need to create a "provider" for your data. Look at what the >>> constructor takes and then implement the interface. >>> >>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote: >>>> Hello! >>>> >>>> I can't understand how to populate data from a resultset object into >>>> datatable. >>>> Anyone have an example? >>>> >>>> Thank you! >>>> >>>> - >>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >>>> For additional commands, e-mail: users-h...@wicket.apache.org >>>> >>>> >>> >>> - >>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >>> For additional commands, e-mail: users-h...@wicket.apache.org >>> >>> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
Yeah, but this doesn't give them an example of how to get the results out of a JDBC result set. This is based on a static, in-memory list of Contact objects. What I would recommend is to look at a Hibernate-based example and come up with the JDBC analog. Here's an example from my Advanced Wicket talk I gave a while back: http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main/java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java At the bottom, there's a data provider which talks to a "repository" to get its data. On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian wrote: > http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html > > -Ursprüngliche Nachricht- > Von: Ivan Dudko [mailto:ivan.du...@gmail.com] > Gesendet: Donnerstag, 11. Februar 2010 15:47 > An: users@wicket.apache.org > Betreff: Re: jdbc > > I already have method that return my data from db as arraylist. And i > use this in iterator() method of dataprovider. > But which object (i think model) i must return? > > 2010/2/11 James Carman : >> You need to create a "provider" for your data. Look at what the >> constructor takes and then implement the interface. >> >> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote: >>> Hello! >>> >>> I can't understand how to populate data from a resultset object into >>> datatable. >>> Anyone have an example? >>> >>> Thank you! >>> >>> - >>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >>> For additional commands, e-mail: users-h...@wicket.apache.org >>> >>> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
AW: jdbc
http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.html -Ursprüngliche Nachricht- Von: Ivan Dudko [mailto:ivan.du...@gmail.com] Gesendet: Donnerstag, 11. Februar 2010 15:47 An: users@wicket.apache.org Betreff: Re: jdbc I already have method that return my data from db as arraylist. And i use this in iterator() method of dataprovider. But which object (i think model) i must return? 2010/2/11 James Carman : > You need to create a "provider" for your data. Look at what the > constructor takes and then implement the interface. > > On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote: >> Hello! >> >> I can't understand how to populate data from a resultset object into >> datatable. >> Anyone have an example? >> >> Thank you! >> >> - >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
I already have method that return my data from db as arraylist. And i use this in iterator() method of dataprovider. But which object (i think model) i must return? 2010/2/11 James Carman : > You need to create a "provider" for your data. Look at what the > constructor takes and then implement the interface. > > On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote: >> Hello! >> >> I can't understand how to populate data from a resultset object into >> datatable. >> Anyone have an example? >> >> Thank you! >> >> - >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: jdbc
You need to create a "provider" for your data. Look at what the constructor takes and then implement the interface. On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko wrote: > Hello! > > I can't understand how to populate data from a resultset object into > datatable. > Anyone have an example? > > Thank you! > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
jdbc
Hello! I can't understand how to populate data from a resultset object into datatable. Anyone have an example? Thank you! - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: wicket + jdbc template app
Thank you! I have just implement it! I am using c3p0 and SQL DAO without Spring or any Persistent framework. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: wicket + jdbc template app
On Thu, Nov 19, 2009 at 10:41 AM, Loritsch, Berin C. wrote: > Do be sure to close anything you open, which includes resultsets, > statements, and connections. Put the close code in "finally" statements > to ensure that you don't fill up your pool with open resources. Open > ResultSets also have matching resources on your database server, so you > can introduce scalability problems if you aren't careful. And this is why we use something like Spring's JDBC support to manage all of that for us (they've already thought of this stuff). > > -Original Message- > From: Clint Checketts [mailto:checke...@gmail.com] > Sent: Thursday, November 19, 2009 8:35 AM > To: users@wicket.apache.org > Subject: Re: wicket + jdbc template app > > My Wicket app I maintain only uses the JdbcTemplate class from Spring. > We > don't use any hibernate or other ORM framework. > > I don't have any code I can give, but I can answer any questions. How > far > have you gotten? > > -Clint > > > On Thu, Nov 19, 2009 at 7:23 AM, James Carman > wrote: > >> Are you saying you don't want to use Spring at all? But, you do want >> to use DBCP or C3P0? >> >> On Thu, Nov 19, 2009 at 7:46 AM, Ivan Dudko > wrote: >> > Hello, guys! >> > >> > I am still could not implement wicket application without any >> > persistence framework and also spring-jdbc. >> > I want to use only connection pooling with dbcp or c3p0. >> > May you provide example for this kind of app. >> > >> > Thank you for answer! >> > >> > > - >> > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> > For additional commands, e-mail: users-h...@wicket.apache.org >> > >> > >> >> - >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
RE: wicket + jdbc template app
DBCP and C3P0 are implementations of the pooled DataSource interface, so all you have to do is bind them to JNDI. Tomcat and other Servlet container vendors have instructions on how to do this. Inside your code, you access it through the JNDI API which looks up the pooled datasource. Do be sure to close anything you open, which includes resultsets, statements, and connections. Put the close code in "finally" statements to ensure that you don't fill up your pool with open resources. Open ResultSets also have matching resources on your database server, so you can introduce scalability problems if you aren't careful. -Original Message- From: Clint Checketts [mailto:checke...@gmail.com] Sent: Thursday, November 19, 2009 8:35 AM To: users@wicket.apache.org Subject: Re: wicket + jdbc template app My Wicket app I maintain only uses the JdbcTemplate class from Spring. We don't use any hibernate or other ORM framework. I don't have any code I can give, but I can answer any questions. How far have you gotten? -Clint On Thu, Nov 19, 2009 at 7:23 AM, James Carman wrote: > Are you saying you don't want to use Spring at all? But, you do want > to use DBCP or C3P0? > > On Thu, Nov 19, 2009 at 7:46 AM, Ivan Dudko wrote: > > Hello, guys! > > > > I am still could not implement wicket application without any > > persistence framework and also spring-jdbc. > > I want to use only connection pooling with dbcp or c3p0. > > May you provide example for this kind of app. > > > > Thank you for answer! > > > > - > > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > > For additional commands, e-mail: users-h...@wicket.apache.org > > > > > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: wicket + jdbc template app
My Wicket app I maintain only uses the JdbcTemplate class from Spring. We don't use any hibernate or other ORM framework. I don't have any code I can give, but I can answer any questions. How far have you gotten? -Clint On Thu, Nov 19, 2009 at 7:23 AM, James Carman wrote: > Are you saying you don't want to use Spring at all? But, you do want > to use DBCP or C3P0? > > On Thu, Nov 19, 2009 at 7:46 AM, Ivan Dudko wrote: > > Hello, guys! > > > > I am still could not implement wicket application without any > > persistence framework and also spring-jdbc. > > I want to use only connection pooling with dbcp or c3p0. > > May you provide example for this kind of app. > > > > Thank you for answer! > > > > - > > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > > For additional commands, e-mail: users-h...@wicket.apache.org > > > > > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > >
Re: wicket + jdbc template app
Are you saying you don't want to use Spring at all? But, you do want to use DBCP or C3P0? On Thu, Nov 19, 2009 at 7:46 AM, Ivan Dudko wrote: > Hello, guys! > > I am still could not implement wicket application without any > persistence framework and also spring-jdbc. > I want to use only connection pooling with dbcp or c3p0. > May you provide example for this kind of app. > > Thank you for answer! > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: wicket + jdbc template app
Hello, guys! I am still could not implement wicket application without any persistence framework and also spring-jdbc. I want to use only connection pooling with dbcp or c3p0. May you provide example for this kind of app. Thank you for answer! - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: wicket + jdbc template app
thank you guys!
Re: wicket + jdbc template app
Hi, I got it working using spring. You can see an template application using spring on wicket stuff: phone book http://static.springsource.org/spring/docs/2.0.8/reference/jdbc.html On Sun, Nov 1, 2009 at 5:07 PM, dtoffe wrote: > >Just set up your connection in your Application subclass and provide a > method to get it from wherever you need it. Use connection pooling. > > Daniel > > > idudko wrote: > > > > Hello, guys! > > > > I want to use wicket with plain jdbc without any persistence framework. > > Where i can find template application for this type of data source? > > > > Thank you for answer! > > > > > > -- > View this message in context: > http://old.nabble.com/wicket-%2B-jdbc-template-app-tp26151790p26152287.html > Sent from the Wicket - User mailing list archive at Nabble.com. > > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > -- Pedro Henrique Oliveira dos Santos
Re: wicket + jdbc template app
Just set up your connection in your Application subclass and provide a method to get it from wherever you need it. Use connection pooling. Daniel idudko wrote: > > Hello, guys! > > I want to use wicket with plain jdbc without any persistence framework. > Where i can find template application for this type of data source? > > Thank you for answer! > > -- View this message in context: http://old.nabble.com/wicket-%2B-jdbc-template-app-tp26151790p26152287.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: wicket + jdbc template app
Do you want to use spring On Nov 1, 2009 10:12 AM, "Ivan Dudko" wrote: Hello, guys! I want to use wicket with plain jdbc without any persistence framework. Where i can find template application for this type of data source? Thank you for answer!
wicket + jdbc template app
Hello, guys! I want to use wicket with plain jdbc without any persistence framework. Where i can find template application for this type of data source? Thank you for answer!
Re: Starting with Wicket, Spring, Maven and JDBC
Wow, Exactly what I was looking for!!! Thanks a lot !! On Thu, Sep 24, 2009 at 7:10 AM, Muro Copenhagen wrote: > Hi Pedro > > Try Appfuse-light with the desired combination: > > https://appfuse-light.dev.java.net/servlets/ProjectDocumentList?folderID=8006&expandFolder=8006&folderID=0 > > It should be at the bottom. > > Best Regards > Muro > > On Thu, Sep 24, 2009 at 12:04 PM, Pedro Sena wrote: > > > I'll check them > > > > Thanks Eric, > > > > On Wed, Sep 23, 2009 at 8:08 PM, Erik Post wrote: > > > > > Well, besides iolite, you could take a look at wicket-phonebook and > > > wicketopia. They're not JDBC but they both come with Spring > > > preconfigured. The phonebook has a couple of example DAO's and iBatis > > > (among others) set up. You could take those as a starting point and > > > 'add' JDBC. > > > > > > Cheers, > > > Erik > > > > > > > > > On Wed, Sep 23, 2009 at 11:33 PM, Pedro Sena > > wrote: > > > > Hi Guys, > > > > > > > > I'm new to Wicket with Spring(I never used Spring before, just Seam). > > I'm > > > > using lolite but it comes with JPA instead of JDBC. > > > > > > > > I would like to know if there is some archetype for the setup that I > > > > described in the title. I already checked wicket stuff if no luck. > > > > > > > > Thanks in advance, > > > > -- > > > > /** > > > > * Pedro Sena > > > > * Systems Architect > > > > * Sun Certified Java Programmer > > > > * Sun Certified Web Component Developer > > > > */ > > > > > > > > > > - > > > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > > > For additional commands, e-mail: users-h...@wicket.apache.org > > > > > > > > > > > > -- > > /** > > * Pedro Sena > > * Systems Architect > > * Sun Certified Java Programmer > > * Sun Certified Web Component Developer > > */ > > > -- /** * Pedro Sena * Systems Architect * Sun Certified Java Programmer * Sun Certified Web Component Developer */
Re: Starting with Wicket, Spring, Maven and JDBC
Hi Pedro Try Appfuse-light with the desired combination: https://appfuse-light.dev.java.net/servlets/ProjectDocumentList?folderID=8006&expandFolder=8006&folderID=0 It should be at the bottom. Best Regards Muro On Thu, Sep 24, 2009 at 12:04 PM, Pedro Sena wrote: > I'll check them > > Thanks Eric, > > On Wed, Sep 23, 2009 at 8:08 PM, Erik Post wrote: > > > Well, besides iolite, you could take a look at wicket-phonebook and > > wicketopia. They're not JDBC but they both come with Spring > > preconfigured. The phonebook has a couple of example DAO's and iBatis > > (among others) set up. You could take those as a starting point and > > 'add' JDBC. > > > > Cheers, > > Erik > > > > > > On Wed, Sep 23, 2009 at 11:33 PM, Pedro Sena > wrote: > > > Hi Guys, > > > > > > I'm new to Wicket with Spring(I never used Spring before, just Seam). > I'm > > > using lolite but it comes with JPA instead of JDBC. > > > > > > I would like to know if there is some archetype for the setup that I > > > described in the title. I already checked wicket stuff if no luck. > > > > > > Thanks in advance, > > > -- > > > /** > > > * Pedro Sena > > > * Systems Architect > > > * Sun Certified Java Programmer > > > * Sun Certified Web Component Developer > > > */ > > > > > > > - > > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > > For additional commands, e-mail: users-h...@wicket.apache.org > > > > > > > -- > /** > * Pedro Sena > * Systems Architect > * Sun Certified Java Programmer > * Sun Certified Web Component Developer > */ >
Re: Starting with Wicket, Spring, Maven and JDBC
I'll check them Thanks Eric, On Wed, Sep 23, 2009 at 8:08 PM, Erik Post wrote: > Well, besides iolite, you could take a look at wicket-phonebook and > wicketopia. They're not JDBC but they both come with Spring > preconfigured. The phonebook has a couple of example DAO's and iBatis > (among others) set up. You could take those as a starting point and > 'add' JDBC. > > Cheers, > Erik > > > On Wed, Sep 23, 2009 at 11:33 PM, Pedro Sena wrote: > > Hi Guys, > > > > I'm new to Wicket with Spring(I never used Spring before, just Seam). I'm > > using lolite but it comes with JPA instead of JDBC. > > > > I would like to know if there is some archetype for the setup that I > > described in the title. I already checked wicket stuff if no luck. > > > > Thanks in advance, > > -- > > /** > > * Pedro Sena > > * Systems Architect > > * Sun Certified Java Programmer > > * Sun Certified Web Component Developer > > */ > > > > - > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org > For additional commands, e-mail: users-h...@wicket.apache.org > > -- /** * Pedro Sena * Systems Architect * Sun Certified Java Programmer * Sun Certified Web Component Developer */
Re: Starting with Wicket, Spring, Maven and JDBC
Well, besides iolite, you could take a look at wicket-phonebook and wicketopia. They're not JDBC but they both come with Spring preconfigured. The phonebook has a couple of example DAO's and iBatis (among others) set up. You could take those as a starting point and 'add' JDBC. Cheers, Erik On Wed, Sep 23, 2009 at 11:33 PM, Pedro Sena wrote: > Hi Guys, > > I'm new to Wicket with Spring(I never used Spring before, just Seam). I'm > using lolite but it comes with JPA instead of JDBC. > > I would like to know if there is some archetype for the setup that I > described in the title. I already checked wicket stuff if no luck. > > Thanks in advance, > -- > /** > * Pedro Sena > * Systems Architect > * Sun Certified Java Programmer > * Sun Certified Web Component Developer > */ > - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Starting with Wicket, Spring, Maven and JDBC
Hi Guys, I'm new to Wicket with Spring(I never used Spring before, just Seam). I'm using lolite but it comes with JPA instead of JDBC. I would like to know if there is some archetype for the setup that I described in the title. I already checked wicket stuff if no luck. Thanks in advance, -- /** * Pedro Sena * Systems Architect * Sun Certified Java Programmer * Sun Certified Web Component Developer */
Re: JDBC Connection for CRUD operations
Just having the driver specified on the classpath doesn't register it.
You have to do a Class.forName("drivernamehere") to register it with
the DriverManager. I'd do that as a ServletContextListener or
something.
On 2/29/08, Nino Saturnino Martinez Vazquez Wael
<[EMAIL PROTECTED]> wrote:
> you need to have which ever driver you specified on classpath..
>
>
> wicketUser wrote:
> > Hi,
> >
> > I am new to Wicket and I don't wish to use hibernate as persistence
> > framework. I am trying to do CRUD operations through JDBC connection to a
> > mysql database.
> >
> > I have added mysql dependency in my project's pom.xml file
> >
> >
> > mysql
> > mysql-connector-java
> > 5.0.5
> >
> >
> > and I can see the connector in the war file.
> >
> > However, when I try to save an object, I get the following error:
> >
> > java.sql.SQLException: No suitable driver
> > at java.sql.DriverManager.getConnection(DriverManager.java:545)
> > at java.sql.DriverManager.getConnection(DriverManager.java:171)
> > at com.mycompany.DBConnection.save(DBConnection.java:20)
> > at
> > com.mycompany.CategoryPage$CategoryForm.onSubmit(CategoryPage.java:35)
> > at
> > org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1328
> > )
> > at
> > org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:776
> > )
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > java:39)
> > at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > sorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:585)
> > at
> > org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInte
> > rface.java:183)
> > at
> > org.apache.wicket.request.target.component.listener.ListenerInterface
> > RequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73)
> > at
> > org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents
> > (AbstractRequestCycleProcessor.java:90)
> > at
> > org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.j
> > ava:1166)
> > at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
> > at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
> > at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
> > at
> > org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:
> > 354)
> > at
> > org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.ja
> > va:194)
> > at
> > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
> > Handler.java:1084)
> > at
> > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
> > 60)
> > at
> > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
> > a:216)
> > at
> > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
> > 81)
> > at
> > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
> > 26)
> > at
> > org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
> >
> > at
> > org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
> > lerCollection.java:206)
> > at
> > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
> > java:114)
> > at
> > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
> > 39)
> > at org.mortbay.jetty.Server.handle(Server.java:324)
> > at
> > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50
> > 5)
> > at
> > org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
> > n.java:842)
> > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
> > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
> > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
> > at
> > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja
> > va:
Re: JDBC Connection for CRUD operations
you need to have which ever driver you specified on classpath.. wicketUser wrote: Hi, I am new to Wicket and I don't wish to use hibernate as persistence framework. I am trying to do CRUD operations through JDBC connection to a mysql database. I have added mysql dependency in my project's pom.xml file mysql mysql-connector-java 5.0.5 and I can see the connector in the war file. However, when I try to save an object, I get the following error: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:545) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.mycompany.DBConnection.save(DBConnection.java:20) at com.mycompany.CategoryPage$CategoryForm.onSubmit(CategoryPage.java:35) at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1328 ) at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:776 ) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInte rface.java:183) at org.apache.wicket.request.target.component.listener.ListenerInterface RequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents (AbstractRequestCycleProcessor.java:90) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.j ava:1166) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316) at org.apache.wicket.RequestCycle.request(RequestCycle.java:493) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java: 354) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.ja va:194) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1084) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3 60) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav a:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1 81) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7 26) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand lerCollection.java:206) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection. java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1 39) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50 5) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio n.java:842) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja va:395) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool .java:450) Can anyone please help me with this? Thanks. -- -Wicket for love -Jme for fun Nino Martinez Wael Java Specialist @ Jayway DK http://www.jayway.dk +45 2936 7684 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JDBC Connection for CRUD operations
What driver did you specify? On Fri, Feb 29, 2008 at 1:17 PM, wicketUser <[EMAIL PROTECTED]> wrote: > > Hi, > > I am new to Wicket and I don't wish to use hibernate as persistence > framework. I am trying to do CRUD operations through JDBC connection to a > mysql database. > > I have added mysql dependency in my project's pom.xml file > > > mysql > mysql-connector-java > 5.0.5 > > > and I can see the connector in the war file. > > However, when I try to save an object, I get the following error: > > java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getConnection(DriverManager.java:545) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at com.mycompany.DBConnection.save(DBConnection.java:20) > at > com.mycompany.CategoryPage$CategoryForm.onSubmit(CategoryPage.java:35) > at > org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1328 > ) > at > org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:776 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. > java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInte > rface.java:183) > at > org.apache.wicket.request.target.component.listener.ListenerInterface > RequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73) > at > org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents > (AbstractRequestCycleProcessor.java:90) > at > org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.j > ava:1166) > at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241) > at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316) > at org.apache.wicket.RequestCycle.request(RequestCycle.java:493) > at > org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java: > 354) > at > org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.ja > va:194) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet > Handler.java:1084) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3 > 60) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav > a:216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1 > 81) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7 > 26) > at > org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) > > at > org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand > lerCollection.java:206) > at > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection. > java:114) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1 > 39) > at org.mortbay.jetty.Server.handle(Server.java:324) > at > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50 > 5) > at > org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio > n.java:842) > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648) > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) > at > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja > va:395) > at > org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool > .java:450) > > > Can anyone please help me with this? > > Thanks. > > -- > View this message in context: > http://www.nabble.com/JDBC-Connection-for-CRUD-operations-tp15757358p15757358.html > Sent from the Wicket - User mailing list archive at Nabble.com. > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JDBC Connection for CRUD operations
Hi, I am new to Wicket and I don't wish to use hibernate as persistence framework. I am trying to do CRUD operations through JDBC connection to a mysql database. I have added mysql dependency in my project's pom.xml file mysql mysql-connector-java 5.0.5 and I can see the connector in the war file. However, when I try to save an object, I get the following error: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:545) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.mycompany.DBConnection.save(DBConnection.java:20) at com.mycompany.CategoryPage$CategoryForm.onSubmit(CategoryPage.java:35) at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1328 ) at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:776 ) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInte rface.java:183) at org.apache.wicket.request.target.component.listener.ListenerInterface RequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents (AbstractRequestCycleProcessor.java:90) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.j ava:1166) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316) at org.apache.wicket.RequestCycle.request(RequestCycle.java:493) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java: 354) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.ja va:194) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1084) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3 60) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav a:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1 81) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7 26) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand lerCollection.java:206) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection. java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1 39) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50 5) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio n.java:842) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja va:395) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool .java:450) Can anyone please help me with this? Thanks. -- View this message in context: http://www.nabble.com/JDBC-Connection-for-CRUD-operations-tp15757358p15757358.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
